Development of J-PARC time-series data archiver using distributed database system

Kikuzawa, Nobuhiro; Yoshii, Akinobu; Ikeda, Hiroshi; Kato, Yuko

Proceedings of 14th International Conference on Accelerator and Large Experimental Physics Control Systems (ICALEPCS 2013) (Internet), p.584 - 586, 2013/10

http://accelconf.web.cern.ch/AccelConf/ICALEPCS2013/papers/tuppc017.pdf

J-PARC is consists of much equipment. In Linac and 3 GeV synchrotron, the data of over the 64,000 EPICS records about these apparatus control has been collected. The data has been being stored by a RDBMS (Rerational Data Base Management System) using Postgre SQL now, but it is not enough in availability, performance, and extendibility. Therefore, we think that the new system architecture excellent in the pliability will be required, which is rich in the pliability and can respond to the data which continues increasing for years to come. In order to deal with this problem, we considered use of distributed database system and constructed the demonstration system using HBase. We present results of these demonstration.